﻿CREATE TABLE [dbo].[OrderDetails] (
    [OrderId]       BIGINT   NOT NULL,
    [MovieDiscId]   BIGINT   NOT NULL,
    [MaxReturnDate] DATETIME NOT NULL,
    [ReturnDate]    DATETIME NULL,
    CONSTRAINT [FK_OrderDetails_MovieDisc] FOREIGN KEY ([MovieDiscId]) REFERENCES [dbo].[MovieDisc] ([Id]),
    CONSTRAINT [FK_OrderDetails_Order] FOREIGN KEY ([OrderId]) REFERENCES [dbo].[Order] ([Id])
);

